The Field Index Tool has three basic functions: it can get the field contents, field index and calculation formula of any field in any currently open Filemaker database. To use it, simply select a file from the pull-down list, then select a field from the pull-down list of fields, then click on the appropriate button. Note that this tool cannot read or return container data. You can definately figure this tool out just by using it, but here's the documentation for reference's sake.
Buttons
Field Contents:
Clicking on this button will return the field contents. The field contents is composed of the field value from every record.
Field Index:
Clicking on this button will return the field index for the field selected. The index is a sorted list of the field contents with any duplicates and blank values removed. Note that the field in question does not have to be indexed or stored in the original file. In fact, the field does not even have to be indexable. You can get the "index" for unstored calculations and global fields.
Field Calculation:
Clicking on this button will return the calculation for the field, if the currently selected field is a calculation field. You must have Applescript enabled, and full access to the file to get the field's calculation.
Hide:
Clicking on this button will simply hide the window for this tool.
Preferences
There are several preferences that can be set for the Field Index Tool. To view the preferences, select "Preferences..." from the scripts menu.
"Sort Field Index":
If this preference is selected, the field index will be sorted when it is returned. If this preference is not selected, the values in the field index will be displayed in the order corresponding with the current record order in the file.
"Sort Field Contents":
If this preference is selected, the field contents will be sorted when it is returned. If this preference is not selected, the values in the field contents will be displayed in the order corresponding with the current record order in the file.
"Remove Empty Values":
If this prefence is selected, any blank values will be removed from the list of field contents. If this preference is not selected, blank values will be displayed in the list.
"Use Custom Delimiter":
The list comprising a field's index or contents is typically returned as a return-seperated list. However, by selecting this option you can change the character that is used to delimit that list. For instance, you could select this option and then enter a semi-colon in the field which appears, and the values of the next field index you got would be seperated by semi-colons. Note that you need to specify the entire delimiter, so in the example above you would actually enter a space and then a semi-colon. There is no character limit on the delimiter that you specify.
